Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	1687861
Missing cells	100915
Missing cells (%)	0.3%
Duplicate rows	168735
Duplicate rows (%)	10.0%
Total size in memory	296.2 MiB
Average record size in memory	184.0 B

Variable types

Unsupported	1
Numeric	15
Boolean	7

Alerts

Dataset has 168735 (10.0%) duplicate rows	Duplicates
`national_inv` is highly overall correlated with `sales_1_month` and 4 other fields	High correlation
`in_transit_qty` is highly overall correlated with `forecast_3_month` and 7 other fields	High correlation
`forecast_3_month` is highly overall correlated with `in_transit_qty` and 6 other fields	High correlation
`forecast_6_month` is highly overall correlated with `in_transit_qty` and 6 other fields	High correlation
`forecast_9_month` is highly overall correlated with `in_transit_qty` and 6 other fields	High correlation
`sales_1_month` is highly overall correlated with `national_inv` and 8 other fields	High correlation
`sales_3_month` is highly overall correlated with `national_inv` and 8 other fields	High correlation
`sales_6_month` is highly overall correlated with `national_inv` and 8 other fields	High correlation
`sales_9_month` is highly overall correlated with `national_inv` and 8 other fields	High correlation
`min_bank` is highly overall correlated with `national_inv` and 5 other fields	High correlation
`perf_6_month_avg` is highly overall correlated with `perf_12_month_avg`	High correlation
`perf_12_month_avg` is highly overall correlated with `perf_6_month_avg`	High correlation
`potential_issue` is highly imbalanced (99.3%)	Imbalance
`oe_constraint` is highly imbalanced (99.8%)	Imbalance
`stop_auto_buy` is highly imbalanced (77.5%)	Imbalance
`rev_stop` is highly imbalanced (99.5%)	Imbalance
`went_on_backorder` is highly imbalanced (94.2%)	Imbalance
`lead_time` has 100894 (6.0%) missing values	Missing
`national_inv` is highly skewed (γ1 = 340.2858003)	Skewed
`in_transit_qty` is highly skewed (γ1 = 166.1834042)	Skewed
`forecast_3_month` is highly skewed (γ1 = 138.9683252)	Skewed
`forecast_6_month` is highly skewed (γ1 = 138.9614272)	Skewed
`forecast_9_month` is highly skewed (γ1 = 143.2988747)	Skewed
`sales_1_month` is highly skewed (γ1 = 196.1199899)	Skewed
`sales_3_month` is highly skewed (γ1 = 141.2863795)	Skewed
`sales_6_month` is highly skewed (γ1 = 139.176712)	Skewed
`sales_9_month` is highly skewed (γ1 = 135.0541915)	Skewed
`min_bank` is highly skewed (γ1 = 131.2126489)	Skewed
`pieces_past_due` is highly skewed (γ1 = 412.3919004)	Skewed
`local_bo_qty` is highly skewed (γ1 = 165.1905479)	Skewed
`sku` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`national_inv` has 108425 (6.4%) zeros	Zeros
`in_transit_qty` has 1344662 (79.7%) zeros	Zeros
`forecast_3_month` has 1177722 (69.8%) zeros	Zeros
`forecast_6_month` has 1084111 (64.2%) zeros	Zeros
`forecast_9_month` has 1033241 (61.2%) zeros	Zeros
`sales_1_month` has 959817 (56.9%) zeros	Zeros
`sales_3_month` has 759225 (45.0%) zeros	Zeros
`sales_6_month` has 647038 (38.3%) zeros	Zeros
`sales_9_month` has 585994 (34.7%) zeros	Zeros
`min_bank` has 872331 (51.7%) zeros	Zeros
`pieces_past_due` has 1662571 (98.5%) zeros	Zeros
`perf_6_month_avg` has 39013 (2.3%) zeros	Zeros
`perf_12_month_avg` has 32975 (2.0%) zeros	Zeros
`local_bo_qty` has 1664518 (98.6%) zeros	Zeros

Reproduction

Analysis started	2023-06-12 13:14:56.065631
Analysis finished	2023-06-12 13:24:26.154579
Duration	9 minutes and 30.09 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

sku
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

national_inv
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	14969
Distinct (%)	0.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	496.11178

Minimum	-27256
Maximum	12334404
Zeros	108425
Zeros (%)	6.4%
Negative	5888
Negative (%)	0.3%
Memory size	12.9 MiB

Quantile statistics

Minimum	-27256
5-th percentile	0
Q1	4
median	15
Q3	80
95-th percentile	922
Maximum	12334404
Range	12361660
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	29615.234
Coefficient of variation (CV)	59.69468
Kurtosis	131276.59
Mean	496.11178
Median Absolute Deviation (MAD)	13
Skewness	340.2858
Sum	8.3736723 × 10⁸
Variance	8.7706207 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	108425	6.4%
2	107869	6.4%
3	90577	5.4%
4	69588	4.1%
5	58916	3.5%
1	58829	3.5%
6	50832	3.0%
7	46399	2.7%
10	46277	2.7%
8	40147	2.4%
Other values (14959)	1010001	59.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-27256	1	< 0.1%
-25414	2	< 0.1%
-22154	2	< 0.1%
-17698	1	< 0.1%
-17669	1	< 0.1%
-13491	1	< 0.1%
-9925	1	< 0.1%
-8230	1	< 0.1%
-8170	1	< 0.1%
-8130	1	< 0.1%

Value	Count	Frequency (%)
12334404	1	< 0.1%
12324456	1	< 0.1%
12315072	1	< 0.1%
12309096	1	< 0.1%
12285100	1	< 0.1%
12181612	1	< 0.1%
12166440	1	< 0.1%
6363276	1	< 0.1%
6352932	1	< 0.1%
6335300	1	< 0.1%

lead_time
Real number (ℝ)

Distinct	32
Distinct (%)	< 0.1%
Missing	100894
Missing (%)	6.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.872267

Minimum	0
Maximum	52
Zeros	10511
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	8
Q3	9
95-th percentile	12
Maximum	52
Range	52
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	7.056024
Coefficient of variation (CV)	0.89631411
Kurtosis	26.237228
Mean	7.872267
Median Absolute Deviation (MAD)	1
Skewness	4.5562954
Sum	12493028
Variance	49.787475
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
8	682186	40.4%
2	337402	20.0%
12	199700	11.8%
4	128537	7.6%
9	123649	7.3%
52	30113	1.8%
3	16253	1.0%
10	14192	0.8%
0	10511	0.6%
14	10314	0.6%
Other values (22)	34110	2.0%
(Missing)	100894	6.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10511	0.6%
1	21	< 0.1%
2	337402	20.0%
3	16253	1.0%
4	128537	7.6%
5	4031	0.2%
6	5365	0.3%
7	209	< 0.1%
8	682186	40.4%
9	123649	7.3%

Value	Count	Frequency (%)
52	30113	1.8%
40	48	< 0.1%
35	35	< 0.1%
30	312	< 0.1%
28	84	< 0.1%
26	105	< 0.1%
25	7	< 0.1%
24	115	< 0.1%
23	14	< 0.1%
22	133	< 0.1%

in_transit_qty
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5230
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	44.052022

Minimum	0
Maximum	489408
Zeros	1344662
Zeros (%)	79.7%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	68
Maximum	489408
Range	489408
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1342.7417
Coefficient of variation (CV)	30.480819
Kurtosis	39606.104
Mean	44.052022
Median Absolute Deviation (MAD)	0
Skewness	166.1834
Sum	74353646
Variance	1802955.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1344662	79.7%
1	36515	2.2%
2	22236	1.3%
3	17189	1.0%
4	15364	0.9%
5	13003	0.8%
6	11384	0.7%
10	8964	0.5%
8	8822	0.5%
7	8131	0.5%
Other values (5220)	201590	11.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1344662	79.7%
1	36515	2.2%
2	22236	1.3%
3	17189	1.0%
4	15364	0.9%
5	13003	0.8%
6	11384	0.7%
7	8131	0.5%
8	8822	0.5%
9	6285	0.4%

Value	Count	Frequency (%)
489408	1	< 0.1%
487680	1	< 0.1%
328060	1	< 0.1%
327156	1	< 0.1%
292093	1	< 0.1%
288960	1	< 0.1%
288768	1	< 0.1%
285365	1	< 0.1%
276703	1	< 0.1%
254688	1	< 0.1%

forecast_3_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	7825
Distinct (%)	0.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	178.11928

Minimum	0
Maximum	1427612
Zeros	1177722
Zeros (%)	69.8%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	300
Maximum	1427612
Range	1427612
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	5026.5531
Coefficient of variation (CV)	28.220151
Kurtosis	25637.55
Mean	178.11928
Median Absolute Deviation (MAD)	0
Skewness	138.96833
Sum	3.0064041 × 10⁸
Variance	25266236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1177722	69.8%
1	31452	1.9%
2	26612	1.6%
5	19740	1.2%
4	18563	1.1%
3	16194	1.0%
10	14370	0.9%
6	13612	0.8%
12	11031	0.7%
20	10946	0.6%
Other values (7815)	347618	20.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1177722	69.8%
1	31452	1.9%
2	26612	1.6%
3	16194	1.0%
4	18563	1.1%
5	19740	1.2%
6	13612	0.8%
7	8152	0.5%
8	10357	0.6%
9	6880	0.4%

Value	Count	Frequency (%)
1427612	1	< 0.1%
1218328	2	< 0.1%
1126656	1	< 0.1%
1103084	1	< 0.1%
1058396	1	< 0.1%
1046592	1	< 0.1%
1037228	1	< 0.1%
1013708	1	< 0.1%
992540	1	< 0.1%
980780	1	< 0.1%

forecast_6_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	11114
Distinct (%)	0.7%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	344.98666

Minimum	0
Maximum	2461360
Zeros	1084111
Zeros (%)	64.2%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	12
95-th percentile	600
Maximum	2461360
Range	2461360
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	9795.1519
Coefficient of variation (CV)	28.392842
Kurtosis	25189.904
Mean	344.98666
Median Absolute Deviation (MAD)	0
Skewness	138.96143
Sum	5.8228919 × 10⁸
Variance	95945000
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1084111	64.2%
1	27857	1.7%
2	26492	1.6%
3	19975	1.2%
4	18782	1.1%
5	16649	1.0%
6	16113	1.0%
10	15810	0.9%
8	12976	0.8%
20	11981	0.7%
Other values (11104)	437114	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1084111	64.2%
1	27857	1.7%
2	26492	1.6%
3	19975	1.2%
4	18782	1.1%
5	16649	1.0%
6	16113	1.0%
7	11512	0.7%
8	12976	0.8%
9	6761	0.4%

Value	Count	Frequency (%)
2461360	1	< 0.1%
2446072	1	< 0.1%
2119148	1	< 0.1%
2109740	1	< 0.1%
2104128	1	< 0.1%
2094336	1	< 0.1%
2087396	1	< 0.1%
2085044	1	< 0.1%
2056820	1	< 0.1%
2036828	1	< 0.1%

forecast_9_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	13662
Distinct (%)	0.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	506.36443

Minimum	0
Maximum	3777304
Zeros	1033241
Zeros (%)	61.2%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	20
95-th percentile	896
Maximum	3777304
Range	3777304
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	14378.924
Coefficient of variation (CV)	28.396393
Kurtosis	27048.452
Mean	506.36443
Median Absolute Deviation (MAD)	0
Skewness	143.29887
Sum	8.5467227 × 10⁸
Variance	2.0675344 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1033241	61.2%
1	26781	1.6%
2	25662	1.5%
3	20716	1.2%
4	19322	1.1%
5	17495	1.0%
6	16611	1.0%
10	16153	1.0%
8	13953	0.8%
12	12425	0.7%
Other values (13652)	485501	28.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1033241	61.2%
1	26781	1.6%
2	25662	1.5%
3	20716	1.2%
4	19322	1.1%
5	17495	1.0%
6	16611	1.0%
7	10402	0.6%
8	13953	0.8%
9	8012	0.5%

Value	Count	Frequency (%)
3777304	1	< 0.1%
3760840	1	< 0.1%
3232820	1	< 0.1%
3229292	1	< 0.1%
3206948	1	< 0.1%
3196364	1	< 0.1%
3158732	1	< 0.1%
3149324	1	< 0.1%
3103460	1	< 0.1%
3062016	1	< 0.1%

sales_1_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5764
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	55.926069

Minimum	0
Maximum	741774
Zeros	959817
Zeros (%)	56.9%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	107
Maximum	741774
Range	741774
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1928.1959
Coefficient of variation (CV)	34.477587
Kurtosis	53855.926
Mean	55.926069
Median Absolute Deviation (MAD)	0
Skewness	196.11999
Sum	94395374
Variance	3717939.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	959817	56.9%
1	144881	8.6%
2	78759	4.7%
3	49410	2.9%
4	37905	2.2%
5	29720	1.8%
6	23695	1.4%
7	18997	1.1%
8	17003	1.0%
10	14605	0.9%
Other values (5754)	313068	18.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	959817	56.9%
1	144881	8.6%
2	78759	4.7%
3	49410	2.9%
4	37905	2.2%
5	29720	1.8%
6	23695	1.4%
7	18997	1.1%
8	17003	1.0%
9	13983	0.8%

Value	Count	Frequency (%)
741774	1	< 0.1%
741762	1	< 0.1%
741750	1	< 0.1%
393665	1	< 0.1%
376025	1	< 0.1%
369425	1	< 0.1%
366191	1	< 0.1%
361803	1	< 0.1%
361239	1	< 0.1%
359505	1	< 0.1%

sales_3_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	10495
Distinct (%)	0.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	175.02593

Minimum	0
Maximum	1105478
Zeros	759225
Zeros (%)	45.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	15
95-th percentile	350
Maximum	1105478
Range	1105478
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	5192.3776
Coefficient of variation (CV)	29.666334
Kurtosis	24198.861
Mean	175.02593
Median Absolute Deviation (MAD)	1
Skewness	141.28638
Sum	2.9541927 × 10⁸
Variance	26960785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	759225	45.0%
1	136966	8.1%
2	81289	4.8%
3	53082	3.1%
4	41533	2.5%
5	34128	2.0%
6	27829	1.6%
7	23243	1.4%
8	20904	1.2%
10	17873	1.1%
Other values (10485)	491788	29.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	759225	45.0%
1	136966	8.1%
2	81289	4.8%
3	53082	3.1%
4	41533	2.5%
5	34128	2.0%
6	27829	1.6%
7	23243	1.4%
8	20904	1.2%
9	17571	1.0%

Value	Count	Frequency (%)
1105478	1	< 0.1%
1104181	1	< 0.1%
1100523	1	< 0.1%
1094112	1	< 0.1%
1091281	1	< 0.1%
1084974	1	< 0.1%
1081560	1	< 0.1%
1076623	1	< 0.1%
1070623	1	< 0.1%
1062979	1	< 0.1%

sales_6_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	14818
Distinct (%)	0.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	341.72884

Minimum	0
Maximum	2146625
Zeros	647038
Zeros (%)	38.3%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	31
95-th percentile	696
Maximum	2146625
Range	2146625
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	9613.1671
Coefficient of variation (CV)	28.13098
Kurtosis	24305.445
Mean	341.72884
Median Absolute Deviation (MAD)	2
Skewness	139.17671
Sum	5.7679044 × 10⁸
Variance	92412982
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	647038	38.3%
1	127076	7.5%
2	79418	4.7%
3	52987	3.1%
4	41716	2.5%
5	34108	2.0%
6	28319	1.7%
7	23244	1.4%
8	21102	1.3%
9	18383	1.1%
Other values (14808)	614469	36.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	647038	38.3%
1	127076	7.5%
2	79418	4.7%
3	52987	3.1%
4	41716	2.5%
5	34108	2.0%
6	28319	1.7%
7	23244	1.4%
8	21102	1.3%
9	18383	1.1%

Value	Count	Frequency (%)
2146625	1	< 0.1%
2145715	1	< 0.1%
2133557	1	< 0.1%
2123946	1	< 0.1%
2117803	1	< 0.1%
2113901	1	< 0.1%
2112231	1	< 0.1%
2098852	1	< 0.1%
2086531	1	< 0.1%
1799099	1	< 0.1%

sales_9_month
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	18341
Distinct (%)	1.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	525.2697

Minimum	0
Maximum	3205172
Zeros	585994
Zeros (%)	34.7%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	47
95-th percentile	1060
Maximum	3205172
Range	3205172
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	14838.614
Coefficient of variation (CV)	28.249514
Kurtosis	22844.806
Mean	525.2697
Median Absolute Deviation (MAD)	4
Skewness	135.05419
Sum	8.8658172 × 10⁸
Variance	2.2018445 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	585994	34.7%
1	120294	7.1%
2	76521	4.5%
3	52294	3.1%
4	41399	2.5%
5	34323	2.0%
6	28784	1.7%
7	23545	1.4%
8	21115	1.3%
9	18744	1.1%
Other values (18331)	684847	40.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	585994	34.7%
1	120294	7.1%
2	76521	4.5%
3	52294	3.1%
4	41399	2.5%
5	34323	2.0%
6	28784	1.7%
7	23545	1.4%
8	21115	1.3%
9	18744	1.1%

Value	Count	Frequency (%)
3205172	1	< 0.1%
3204929	1	< 0.1%
3201035	1	< 0.1%
3197338	1	< 0.1%
3182148	1	< 0.1%
3167394	1	< 0.1%
3163794	1	< 0.1%
3120875	1	< 0.1%
3119450	1	< 0.1%
2758103	1	< 0.1%

min_bank
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5568
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	52.772303

Minimum	0
Maximum	313319
Zeros	872331
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	125
Maximum	313319
Range	313319
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1254.9831
Coefficient of variation (CV)	23.781094
Kurtosis	23549.24
Mean	52.772303
Median Absolute Deviation (MAD)	0
Skewness	131.21265
Sum	89072260
Variance	1574982.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	872331	51.7%
1	252498	15.0%
2	113010	6.7%
3	36035	2.1%
4	22180	1.3%
5	15929	0.9%
6	12059	0.7%
7	9574	0.6%
8	7841	0.5%
15	7375	0.4%
Other values (5558)	339028	20.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	872331	51.7%
1	252498	15.0%
2	113010	6.7%
3	36035	2.1%
4	22180	1.3%
5	15929	0.9%
6	12059	0.7%
7	9574	0.6%
8	7841	0.5%
9	6083	0.4%

Value	Count	Frequency (%)
313319	1	< 0.1%
311423	1	< 0.1%
310427	1	< 0.1%
309667	1	< 0.1%
308055	1	< 0.1%
307627	1	< 0.1%
291059	1	< 0.1%
205786	1	< 0.1%
204803	1	< 0.1%
203734	1	< 0.1%

potential_issue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1686953
True	907
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1686953	99.9%
True	907	0.1%
(Missing)	1	< 0.1%

pieces_past_due
Real number (ℝ)

SKEWED ZEROS

Distinct	826
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.043724

Minimum	0
Maximum	146496
Zeros	1662571
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	146496
Range	146496
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	236.0165
Coefficient of variation (CV)	115.48355
Kurtosis	207663.23
Mean	2.043724
Median Absolute Deviation (MAD)	0
Skewness	412.3919
Sum	3449520
Variance	55703.788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1662571	98.5%
1	3917	0.2%
2	2187	0.1%
4	1294	0.1%
3	1217	0.1%
5	1077	0.1%
6	836	< 0.1%
12	763	< 0.1%
10	744	< 0.1%
8	625	< 0.1%
Other values (816)	12629	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1662571	98.5%
1	3917	0.2%
2	2187	0.1%
3	1217	0.1%
4	1294	0.1%
5	1077	0.1%
6	836	< 0.1%
7	488	< 0.1%
8	625	< 0.1%
9	401	< 0.1%

Value	Count	Frequency (%)
146496	1	< 0.1%
137625	1	< 0.1%
98776	1	< 0.1%
87689	1	< 0.1%
83600	1	< 0.1%
74084	1	< 0.1%
61144	1	< 0.1%
59136	1	< 0.1%
36452	1	< 0.1%
34368	1	< 0.1%

perf_6_month_avg
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	102
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-6.8720588

Minimum	-99
Maximum	1
Zeros	39013
Zeros (%)	2.3%
Negative	129478
Negative (%)	7.7%
Memory size	12.9 MiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.63
median	0.82
Q3	0.97
95-th percentile	1
Maximum	1
Range	100
Interquartile range (IQR)	0.34

Descriptive statistics

Standard deviation	26.556357
Coefficient of variation (CV)	-3.864396
Kurtosis	8.1173951
Mean	-6.8720588
Median Absolute Deviation (MAD)	0.15
Skewness	-3.1806218
Sum	-11599073
Variance	705.24009
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.99	143757	8.5%
1	132329	7.8%
-99	129478	7.7%
0.73	106468	6.3%
0.98	83611	5.0%
0.97	62531	3.7%
0.78	46262	2.7%
0.95	44152	2.6%
0.96	39850	2.4%
0.82	39591	2.3%
Other values (92)	859831	50.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	129478	7.7%
0	39013	2.3%
0.01	572	< 0.1%
0.02	1053	0.1%
0.03	703	< 0.1%
0.04	652	< 0.1%
0.05	1218	0.1%
0.06	1145	0.1%
0.07	2303	0.1%
0.08	1674	0.1%

Value	Count	Frequency (%)
1	132329	7.8%
0.99	143757	8.5%
0.98	83611	5.0%
0.97	62531	3.7%
0.96	39850	2.4%
0.95	44152	2.6%
0.94	36733	2.2%
0.93	34815	2.1%
0.92	22360	1.3%
0.91	31151	1.8%

perf_12_month_avg
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	102
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-6.4379467

Minimum	-99
Maximum	1
Zeros	32975
Zeros (%)	2.0%
Negative	122050
Negative (%)	7.2%
Memory size	12.9 MiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.66
median	0.81
Q3	0.95
95-th percentile	0.99
Maximum	1
Range	100
Interquartile range (IQR)	0.29

Descriptive statistics

Standard deviation	25.843331
Coefficient of variation (CV)	-4.0142195
Kurtosis	8.9055032
Mean	-6.4379467
Median Absolute Deviation (MAD)	0.15
Skewness	-3.3021812
Sum	-10866353
Variance	667.87777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.99	132425	7.8%
-99	122050	7.2%
0.78	117662	7.0%
0.98	92825	5.5%
0.97	66029	3.9%
0.96	63441	3.8%
0.66	53184	3.2%
0.9	47174	2.8%
0.95	45728	2.7%
1	43675	2.6%
Other values (92)	903667	53.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	122050	7.2%
0	32975	2.0%
0.01	2458	0.1%
0.02	420	< 0.1%
0.03	563	< 0.1%
0.04	1026	0.1%
0.05	646	< 0.1%
0.06	817	< 0.1%
0.07	1141	0.1%
0.08	1496	0.1%

Value	Count	Frequency (%)
1	43675	2.6%
0.99	132425	7.8%
0.98	92825	5.5%
0.97	66029	3.9%
0.96	63441	3.8%
0.95	45728	2.7%
0.94	38752	2.3%
0.93	31870	1.9%
0.92	30160	1.8%
0.91	29820	1.8%

local_bo_qty
Real number (ℝ)

SKEWED ZEROS

Distinct	654
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.62645065

Minimum	0
Maximum	12530
Zeros	1664518
Zeros (%)	98.6%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	12530
Range	12530
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	33.722242
Coefficient of variation (CV)	53.830643
Kurtosis	38154.955
Mean	0.62645065
Median Absolute Deviation (MAD)	0
Skewness	165.19055
Sum	1057361
Variance	1137.1896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1664518	98.6%
1	7151	0.4%
2	2982	0.2%
3	1716	0.1%
4	1224	0.1%
5	979	0.1%
6	686	< 0.1%
7	552	< 0.1%
10	504	< 0.1%
8	444	< 0.1%
Other values (644)	7104	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1664518	98.6%
1	7151	0.4%
2	2982	0.2%
3	1716	0.1%
4	1224	0.1%
5	979	0.1%
6	686	< 0.1%
7	552	< 0.1%
8	444	< 0.1%
9	348	< 0.1%

Value	Count	Frequency (%)
12530	1	< 0.1%
10045	1	< 0.1%
10024	1	< 0.1%
8600	1	< 0.1%
7812	1	< 0.1%
7048	1	< 0.1%
7000	1	< 0.1%
6965	1	< 0.1%
6955	1	< 0.1%
6732	1	< 0.1%

deck_risk
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1300377
True	387483
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1300377	77.0%
True	387483	23.0%
(Missing)	1	< 0.1%

oe_constraint
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1687615
True	245
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1687615	> 99.9%
True	245	< 0.1%
(Missing)	1	< 0.1%

ppap_risk
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1484026
True	203834
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1484026	87.9%
True	203834	12.1%
(Missing)	1	< 0.1%

stop_auto_buy
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

True	1626774
False	61086
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	1626774	96.4%
False	61086	3.6%
(Missing)	1	< 0.1%

rev_stop
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1687129
True	731
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1687129	> 99.9%
True	731	< 0.1%
(Missing)	1	< 0.1%

went_on_backorder
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

False	1676567
True	11293
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1676567	99.3%
True	11293	0.7%
(Missing)	1	< 0.1%

Auto

Heatmap
Table

	national_inv	lead_time	in_transit_qty	forecast_3_month	forecast_6_month	forecast_9_month	sales_1_month	sales_3_month	sales_6_month	sales_9_month	min_bank	pieces_past_due	perf_6_month_avg	perf_12_month_avg	local_bo_qty	potential_issue	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
national_inv	1.000	-0.042	0.376	0.149	0.186	0.204	0.541	0.556	0.570	0.579	0.512	0.013	0.125	0.117	0.029	0.000	0.002	0.000	0.005	0.000	0.000	0.000
lead_time	-0.042	1.000	-0.059	-0.122	-0.131	-0.131	-0.084	-0.086	-0.085	-0.081	0.013	-0.009	-0.071	-0.080	-0.011	0.006	0.366	0.005	0.029	0.373	0.010	0.018
in_transit_qty	0.376	-0.059	1.000	0.543	0.572	0.580	0.603	0.587	0.574	0.566	0.552	0.122	0.122	0.121	0.171	0.013	0.004	0.000	0.000	0.004	0.000	0.000
forecast_3_month	0.149	-0.122	0.543	1.000	0.910	0.870	0.552	0.546	0.525	0.511	0.420	0.197	0.127	0.124	0.184	0.000	0.005	0.000	0.002	0.000	0.000	0.000
forecast_6_month	0.186	-0.131	0.572	0.910	1.000	0.958	0.609	0.612	0.593	0.579	0.453	0.179	0.160	0.157	0.176	0.000	0.005	0.000	0.002	0.000	0.000	0.000
forecast_9_month	0.204	-0.131	0.580	0.870	0.958	1.000	0.633	0.643	0.628	0.614	0.467	0.170	0.178	0.175	0.171	0.000	0.005	0.000	0.003	0.000	0.000	0.000
sales_1_month	0.541	-0.084	0.603	0.552	0.609	0.633	1.000	0.915	0.885	0.873	0.638	0.105	0.185	0.181	0.167	0.000	0.003	0.000	0.003	0.006	0.000	0.000
sales_3_month	0.556	-0.086	0.587	0.546	0.612	0.643	0.915	1.000	0.963	0.947	0.640	0.104	0.196	0.191	0.164	0.000	0.006	0.000	0.002	0.004	0.000	0.000
sales_6_month	0.570	-0.085	0.574	0.525	0.593	0.628	0.885	0.963	1.000	0.983	0.640	0.100	0.201	0.195	0.159	0.000	0.006	0.000	0.002	0.004	0.000	0.000
sales_9_month	0.579	-0.081	0.566	0.511	0.579	0.614	0.873	0.947	0.983	1.000	0.641	0.096	0.203	0.197	0.156	0.000	0.006	0.000	0.002	0.003	0.000	0.000
min_bank	0.512	0.013	0.552	0.420	0.453	0.467	0.638	0.640	0.640	0.641	1.000	0.091	0.109	0.105	0.154	0.009	0.006	0.000	0.006	0.010	0.000	0.000
pieces_past_due	0.013	-0.009	0.122	0.197	0.179	0.170	0.105	0.104	0.100	0.096	0.091	1.000	-0.052	-0.052	0.094	0.000	0.001	0.000	0.000	0.000	0.000	0.000
perf_6_month_avg	0.125	-0.071	0.122	0.127	0.160	0.178	0.185	0.196	0.201	0.203	0.109	-0.052	1.000	0.929	-0.002	0.004	0.232	0.003	0.039	0.250	0.033	0.012
perf_12_month_avg	0.117	-0.080	0.121	0.124	0.157	0.175	0.181	0.191	0.195	0.197	0.105	-0.052	0.929	1.000	-0.003	0.004	0.237	0.003	0.038	0.244	0.034	0.012
local_bo_qty	0.029	-0.011	0.171	0.184	0.176	0.171	0.167	0.164	0.159	0.156	0.154	0.094	-0.002	-0.003	1.000	0.000	0.003	0.013	0.001	0.001	0.000	0.009
potential_issue	0.000	0.006	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.009	0.000	0.004	0.004	0.000	1.000	0.002	0.013	0.009	0.002	0.000	0.014
deck_risk	0.002	0.366	0.004	0.005	0.005	0.005	0.003	0.006	0.006	0.006	0.006	0.001	0.232	0.237	0.003	0.002	1.000	0.000	0.037	0.140	0.009	0.012
oe_constraint	0.000	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	0.003	0.013	0.013	0.000	1.000	0.004	0.002	0.000	0.003
ppap_risk	0.005	0.029	0.000	0.002	0.002	0.003	0.003	0.002	0.002	0.002	0.006	0.000	0.039	0.038	0.001	0.009	0.037	0.004	1.000	0.033	0.020	0.009
stop_auto_buy	0.000	0.373	0.004	0.000	0.000	0.000	0.006	0.004	0.004	0.003	0.010	0.000	0.250	0.244	0.001	0.002	0.140	0.002	0.033	1.000	0.050	0.002
rev_stop	0.000	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.033	0.034	0.000	0.000	0.009	0.000	0.020	0.050	1.000	0.001
went_on_backorder	0.000	0.018	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.012	0.012	0.009	0.014	0.012	0.003	0.009	0.002	0.001	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	sku	national_inv	lead_time	forecast_3_month	forecast_6_month	forecast_9_month	sales_9_month	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
0	1026827	0.0	NaN	0.0	0.0	0.0	0.0	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No
1	1043384	2.0	9.0	0.0	0.0	0.0	0.0	0.0	No	0.99	0.99	No	No	No	Yes	No	No
2	1043696	2.0	NaN	0.0	0.0	0.0	0.0	0.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
3	1043852	7.0	8.0	0.0	0.0	0.0	0.0	1.0	No	0.10	0.13	No	No	No	Yes	No	No
4	1044048	8.0	NaN	0.0	0.0	0.0	4.0	2.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
5	1044198	13.0	8.0	0.0	0.0	0.0	0.0	0.0	No	0.82	0.87	No	No	No	Yes	No	No
6	1044643	1095.0	NaN	0.0	0.0	0.0	0.0	4.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
7	1045098	6.0	2.0	0.0	0.0	0.0	0.0	0.0	No	0.00	0.00	Yes	No	Yes	Yes	No	No
8	1045815	140.0	NaN	15.0	114.0	152.0	0.0	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No
9	1045867	4.0	8.0	0.0	0.0	0.0	0.0	0.0	No	0.82	0.87	No	No	No	Yes	No	No

	sku	national_inv	lead_time	in_transit_qty	forecast_3_month	forecast_6_month	forecast_9_month	sales_1_month	sales_3_month	sales_6_month	sales_9_month	min_bank	potential_issue	pieces_past_due	perf_6_month_avg	perf_12_month_avg	local_bo_qty	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
1687851	1373539	-6.0	9.0	36.0	130.0	130.0	130.0	0.0	0.0	54.0	57.0	3.0	No	0.0	0.03	0.10	42.0	No	No	No	Yes	No	No
1687852	1478683	2.0	8.0	0.0	966.0	966.0	1116.0	47.0	512.0	1361.0	2060.0	455.0	No	0.0	0.84	0.77	46.0	No	No	No	Yes	No	No
1687853	1489920	0.0	2.0	0.0	2071.0	3025.0	3412.0	4.0	764.0	764.0	765.0	657.0	No	0.0	0.98	0.99	4.0	No	No	No	No	No	Yes
1687854	1392420	124.0	8.0	140.0	410.0	780.0	1240.0	128.0	464.0	849.0	1074.0	111.0	No	0.0	0.85	0.90	1.0	No	No	No	Yes	No	No
1687855	1407754	0.0	2.0	0.0	10.0	10.0	10.0	0.0	5.0	7.0	7.0	0.0	No	0.0	0.69	0.69	5.0	Yes	No	No	Yes	No	No
1687856	1373987	-1.0	NaN	0.0	5.0	7.0	9.0	1.0	3.0	3.0	8.0	0.0	No	0.0	-99.00	-99.00	1.0	No	No	No	Yes	No	No
1687857	1524346	-1.0	9.0	0.0	7.0	9.0	11.0	0.0	8.0	11.0	12.0	0.0	No	0.0	0.86	0.84	1.0	Yes	No	No	No	No	Yes
1687858	1439563	62.0	9.0	16.0	39.0	87.0	126.0	35.0	63.0	153.0	205.0	12.0	No	0.0	0.86	0.84	6.0	No	No	No	Yes	No	No
1687859	1502009	19.0	4.0	0.0	0.0	0.0	0.0	2.0	7.0	12.0	20.0	1.0	No	0.0	0.73	0.78	1.0	No	No	No	Yes	No	No
1687860	(1687860 rows)	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	national_inv	lead_time	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder	# duplicates
12400	0.0	NaN	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No	6921
27798	2.0	12.0	0.0	No	0.78	0.78	No	No	No	Yes	No	No	3140
21699	2.0	4.0	0.0	No	0.73	0.78	No	No	No	Yes	No	No	2690
91559	13.0	12.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No	2683
27757	2.0	12.0	0.0	No	0.63	0.72	No	No	No	Yes	No	No	2534
80254	10.0	12.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No	2253
37504	3.0	12.0	0.0	No	0.63	0.72	No	No	No	Yes	No	No	2169
27778	2.0	12.0	0.0	No	0.73	0.79	No	No	No	Yes	No	No	2163
91562	13.0	12.0	1.0	No	0.58	0.58	Yes	No	No	Yes	No	No	2137
26693	2.0	9.0	0.0	No	0.70	0.66	No	No	No	Yes	No	No	2082

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring